﻿CREATE TABLE [dbo].[Inquiries] (
    [Id]                                    NVARCHAR (100) NOT NULL,
    [Title]                                 NVARCHAR (MAX) NOT NULL,
    [DateInitiated]                         DATETIME       NOT NULL,
    [DateCompleted]                         DATETIME       NOT NULL,
    [Link]                                  NVARCHAR (MAX) NOT NULL,
    [Status]                                NVARCHAR (MAX) NOT NULL,
    [LastModified]                          DATETIME       NOT NULL,
    [ParliamentNumber]                      INT            NOT NULL,
    [Chamber]                               NVARCHAR (MAX) NOT NULL,
    [Committee_Id]                          NVARCHAR (100) NOT NULL,
    [InquiryGenericSearchResult_Inquiry_Id] NVARCHAR (100) NOT NULL,
    [Bill_Id]                               NVARCHAR (100) NULL
);























